*******************************************************
* Lyle 05 Jan 11: 						              *
*	-this program serves as a base shell for all	  *
*	 stata do files					                  *
*******************************************************


********************************
* Standard Stata Configuration *
********************************
clear all
set mem 999m
capture log close
set logtype text
cap cd "C:\Users\ejm5\Google Drive\2016_Research\Unemployment_MILEX"
cap cd "C:\Users\Jordan.Becker\Desktop\GD\2016_Research\Unemployment_MILEX"
cap cd "\\usnatonetapp01.eur.state.sbu\profiles\beckerjm\Desktop\2016_Research\Unemployment_MILEX"
log using "log\correlates_tables1_2_4_5.log", replace


*********************
* Prepare Variables *
*********************
use "dta\2016_02_09_uem", clear
sort ccode year
xtset ccode year


********************
* Analyze the Data *
********************
set more off
sort ccode year
xtset ccode year

*TABLE 1 Pairwise Correlation between input metrics, output metrics, and Haesebrouck Scores*
#delimit;
pwcorr haesebrouck_score l3.milburden l3.equipment operating l3.personnel l3.infrastructure eda_deployability eda_sustainability 
if year==2011, star(5);

*TABLE 2 Pairwise Correlation between input metrics, deployability and sustainability*
# delimit;
pwcorr l3.milburden l3.equipment operating l3.personnel l3.infrastructure eda_deployability eda_sustainability, star(5);

*TABLE 4 Pairwise Correlation between input metrics and IISS metrics*
#delimit;
pwcorr l3.milburden l3.equipment operating l3.personnel l3.infrastructure human_mobilization_active rotary_personnel tanks_personnel navy_personnel 
bluewater_totalnavy deployed_personnel, star(5);

*TABLE 5 Pairwise Correlation between input metrics and collaborative expenditure*
#delimit;
pwcorr l3.milburden l3.equipment operating l3.personnel l3.infrastructure collaborativeprocurementexpendit collaborativertexpenditure europeancollaborativertexpenditu, star(5);

